Offset depending on date

[Brendon]

What I'm looking to do is have a cell look at a day and determine
whether or not to calculate something.

I have a mileage log that I enter mileage for the month. As I enter
the day ending mileage in one cell, it populates as shown

12/01 THU 1225 1250
12/02 FRI 1250 1275
12/03 SAT 1275 1275
12/04 SUN 1275 1275
12/05 MON 1275 1300

What I would like to do is have it not show the mileage for Sat and
Sun as I don't work these days and just copy down to Monday.

The current formula I have, which doesn't work is:


=IF(ISBLANK(D5),"",IF(WEEKDAY(A6,"1"),"Maybe",IF(WEEKDAY(A6,"7"),"Almost",D5)))

Any help is appreciated.

 

[GS]

Brendon laid this down on his screen :

What I'm looking to do is have a cell look at a day and determine
whether or not to calculate something.

I have a mileage log that I enter mileage for the month. As I enter
the day ending mileage in one cell, it populates as shown

12/01 THU 1225 1250
12/02 FRI 1250 1275
12/03 SAT 1275 1275
12/04 SUN 1275 1275
12/05 MON 1275 1300

What I would like to do is have it not show the mileage for Sat and
Sun as I don't work these days and just copy down to Monday.

The current formula I have, which doesn't work is:


=IF(ISBLANK(D5),"",IF(WEEKDAY(A6,"1"),"Maybe",IF(WEEKDAY(A6,"7"),"Almost",D5)))

Any help is appreciated.

The obvious Q to ask here is...

If you don't work Sat/Sun then why are these days in your list?

 

[GS]

GS presented the following explanation :

Brendon laid this down on his screen :

The obvious Q to ask here is...

If you don't work Sat/Sun then why are these days in your list?

More Qs...

Not sure why you are automatically populating the start mileage for
the next day. Is the vehicle not used for personal stuff Sat/Sun? If so
then you'll have to enter the start odometer reading for Mon as a
constant. Same holds true for personal use of the vehicle Mon-Fri after
working hours.

Is your mileage log being used in tax filing? If so, (using odometer
readings) subtract business mileage from total mileage to get personal
mileage. Divide business mileage by total mileage to get
%UseForBusiness. Multiply total operating expenses(fuel, service &
repairs, insurance, etc.) by %UseForBusiness to get 'elligible vehicle
expense'.