# šŸ—“ Month, Day, and Year Math Functions **URL:** \ **Category:** Ask for Help\ **Created:** [October 9, 2020, 12:12am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937 "2020-10-09T00:12:01Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 12:12am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/1 "2020-10-09T00:12:01Z")
# Woohoo! `Month()`, `Day()`, `Year()` Now we just need hour, minute and second? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c086baae796c66a0baf4a49b67799dcafb93fc4c.jpeg) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 9, 2020, 12:13am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/2 "2020-10-09T00:13:48Z")
You give people a Year, theyā€™ll ask for a Second! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 12:20am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/3 "2020-10-09T00:20:13Z")
Seriously. This is super helpful! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 12:22am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/4 "2020-10-09T00:22:26Z")
Is this new, too? The ability to delete a spreadsheet column from GDE? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/86bc57d1c45a396049270d51591e6ababa2301c4.jpeg) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 12:58am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/5 "2020-10-09T00:58:21Z")
Ohā€¦and `Weeknum()`! I use this ALL THE TIME for weekly records, logs and leaderboard! ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [October 9, 2020, 1:02am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/6 "2020-10-09T01:02:41Z")
All this new date format options are super helpful! Thanks!! šŸ˜ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 9, 2020, 1:11am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/7 "2020-10-09T01:11:51Z")
@yinon_raviv Now you can use this for your 100% Glide Sheets app. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [October 9, 2020, 1:24am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/8 "2020-10-09T01:24:49Z")
> [@Robert\_Petitto](#): > > Is this new, too? The ability to delete a spreadsheet column from GDE? This shouldnā€™t be a thing. Are you sure this is not a Glide Table? ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [October 9, 2020, 1:25am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/9 "2020-10-09T01:25:12Z")
Sorry @Robert_Petitto Is that pretty Month column getting the value from Date column? Thatā€™s what I really need ā€¦, not independent date values with different formats in different columnsā€¦ šŸ¤” ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 1:33am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/10 "2020-10-09T01:33:18Z")
Yep! Getting it from the date column! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 1:34am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/11 "2020-10-09T01:34:39Z")
Ah. It was a Glide table. šŸ™ˆ ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [October 9, 2020, 3:33am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/12 "2020-10-09T03:33:13Z")
This is great ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [October 9, 2020, 4:50am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/13 "2020-10-09T04:50:36Z")
Not posible using google sheets? How do you do that? How do you call the value? Could I see the insights of the month. column for example? Thanks. @Robert_Petitto ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 9, 2020, 4:55am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/14 "2020-10-09T04:55:17Z")
Just call month(X) and replace X by the datetime column. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [October 9, 2020, 4:57am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/15 "2020-10-09T04:57:15Z")
But in excel? This wouldnā€™t be newā€¦ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 9, 2020, 5:12am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/16 "2020-10-09T05:12:05Z")
No you do this in a math column. ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [October 9, 2020, 6:18am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/17 "2020-10-09T06:18:56Z")
+1 for WEEKNUM() ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [October 9, 2020, 6:51am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/18 "2020-10-09T06:51:48Z")
If it only came last week šŸ¤¦šŸ»ā€ā™‚ļøšŸ¤£ ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [October 9, 2020, 10:13am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/19 "2020-10-09T10:13:49Z")
Thanks @ThinhDinh Seems that date maths are not working for meā€¦ Iā€™m using google sheets. Missing something? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0ad97b96b8ab594ac261cbf2b1d0c7954ff9be95.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 9, 2020, 10:25am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/20 "2020-10-09T10:25:46Z")
Probably thereā€™s a bug going around with the math column. You can try refreshing your editor tab. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/387c584f90900349ba604928c8c8bae92b57f765.png) [Next page](https://community.glideapps.com/t/month-day-and-year-math-functions/16937.md?page=2)