how to make sure at least one cell has a date

3

3earth

New Member
Joined
Mar 21, 2010
Messages
17
I need to make sure that one cell has a date before allowing the user to close/save.

Cells
E17 F17 G17
E18 F18 G18
E19 F19 G19
E20 F20 G20
E21 F21 G21
E22 F22 G22
E23 F23 G23

They are all formated to date (short).

Thanks for looking.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Question Question
Scoring weighted permutations
Replies
1
Views
219
StephenCrump
S
N
  • Question Question
Count - specific consecutive order
Replies
6
Views
1K
Peter_SSs
Peter_SSs
U
  • Question Question
Seeking Help with CELLS Property in VBA
2
Replies
13
Views
633
Alex Blakenburg
A
A
  • Question Question
Finance P/L and Day P/L Formula
Replies
1
Views
275
awoohaw
awoohaw
I
  • Solved
Need help with days remaining formula
Replies
5
Views
248
Vogateer
V

Forum statistics

Threads
1,223,958
Messages
6,175,636
Members
452,662
Latest member
Aman1997

Share this page

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