TODAT formula

hii

New Member
Joined
Oct 28, 2020
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
I opened up a weekly schedule template and I am trying to enter the formula =AND(B4>TODAY(),B4<=(TODAY()+7))
but it is not working. I get January 0, 1900 on B4 that is it. I want to have the first column as todays date for which I used =TODAY() and then =TODAY()+1 and so on. Which works for now.
I want to make it so that I have the next seven days in front of me and I want to be able to figure out if I can exclude Saturday and Sunday from the formula.
HELP.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
OK so how do I make sure it applies all across the week. When I enter it only works for Column C. Sorry I'm a newb
 
Upvote 0
Also if I were to include the weekend how would it differ from this formula?
 
Upvote 0
You need to enter the formula in col C & then drag across as far as needed.
 
Upvote 0
You need to enter the formula in col C & then drag across as far as needed.
So I entered the formula, pressed enter and then just click and select all the other columns I need? Probably not because that's not working?
 
Upvote 0
You need to drag the formula across, select C4 & then click & hold the drag handle (the little square in the bottom left corner of the cell) then drag across.
 
Upvote 0
You need to drag the formula across, select C4 & then click & hold the drag handle (the little square in the bottom left corner of the cell) then drag across.
Ok so I got it figured out. Can you explain what I would need to enter if I wanted to include the weekends in the spreadsheets?
This has been so helpful by the way. Thank you.
 
Upvote 0
Just use
VBA Code:
=B4+1
and drag across
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top