Solved: Date Formula

[blackie42]

Hi

Is there a formula for dates that will take account of weekends e.g.

F2 = date

C3 = day before (=(F2)-1) - would like it to automatically take account of
weekend so in effect for monday it would be 3 days before.

Any help appreciated

thanks

[JONvdHeyden]

Hello

You could use WORKDAY()

=WORKDAY(F2,-1)

Where F2 houses the date, will return the previous working day. So if F2 holds 05 Jan 09 (Monday) then the formula will return 02 Jan 09 (Friday).

You need analysis toolpak installed for this function to work. Tools > Addins > check Analysis Toolpak

[blackie42]

Thank v mich - works fine now

regards

Jon