Next Friday's Date Using Cell Formulae

C

Celtic_Avenger

I have within my spreadsheet the requirement for two dates to be shown.

The first is simple to create, todays date.

Today()

The second requires a little more knowledge to obtain.

I need the second date to show the date of the next friday afte
Today's date, unless todays date is a friday, and then the second dat
will also whow today's date.

Thanks for any help you can give!

Celtic_Avenger
:confused: :confused: :confused: :confused: :confused
 
R

Ron de Bruin

Try this with =Now() in J1

=IF(WEEKDAY(J1,2)= 5,NOW(),NOW()+5-WEEKDAY(J1,2))

I use weekday type 2 (that = monday =1)
 
T

Tom Ogilvy

=B3+5-WEEKDAY(B3,2)+(WEEKDAY(B3,2)>5)*7

where B3 holds the date, or substitute that with Today()

=Today()+5-WEEKDAY(Today(),2)+(Weekday(Today(),2)>5)*7

If you won't look at the sheet on weekends, you can remove the Last part
+(Weekday(today(),2)>5)*7
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Next Firday Date Calculation in VBA 1
today's date static 1
Set day of week to display in date field 2
Need help with Date formula.... 3
Formula to return Friday's date: m/d/yyyy 12
Setting traffic lights based on todays date against target dates 2
change =NOW() to permanent date string 4
figure date for next week 2

Top